create SEQUENCE CATEGORY_SEQ start with 1
create sequence SCOPE_SEQ start with 32
create sequence LAFADMIN_SEQ start with 2
create sequence USERINFO_SEQ start with 13
create sequence NOTICE_SEQ start with 90
create sequence LEAVE_SEQ start with 5
create sequence APPLY_SEQ start with 4
create sequence QUESTION_SEQ start with 17


CREATE TABLE LAF.CATEGORY
(
    CATE_ID NUMBER(*) PRIMARY KEY NOT NULL,
    CATE_NAME VARCHAR2(20) NOT NULL,
    DISPLAY NUMBER(*) DEFAULT 1 NOT NULL
);

INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '卡', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '钥匙', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '钱包', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, 'U盘', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '书籍', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '生活用品', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '电子设备', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '服饰衣帽', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '其他', 1);

CREATE TABLE LAF.QUESTION
(
    QUE_ID NUMBER(*) PRIMARY KEY NOT NULL,
    TITLE VARCHAR2(50) NOT NULL
);

INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (1, '您母亲的姓名是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (2, '您父亲的姓名是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (3, '您配偶的姓名是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (4, '您的出生地是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (5, '您喜欢的明星是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (6, '您喜欢的歌曲是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (7, '您小学班主任的名字是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (8, '您初中班主任的名字是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (9, '您高中班主任的名字是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (10, '您的小学校名是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (11, '您的初中校名是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (12, '您的高中校名是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (13, '您的学号（或工号）是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (14, '您父亲的生日是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (15, '您母亲的生日是?');
INSERT INTO LAF.QUESTION (QUE_ID, TITLE) VALUES (16, '您配偶的生日是?');

CREATE TABLE LAF.SCOPE
(
    SCOPE_ID NUMBER(*) PRIMARY KEY NOT NULL,
    LOC_NAME VARCHAR2(20) NOT NULL,
    DISPLAY NUMBER(*) DEFAULT 1 NOT NULL
);

INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (1, '全校', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (2, '院教学大楼', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (3, '静远楼', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (4, '实验大楼', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (5, '行政楼', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (6, '图书馆', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (7, '体育馆', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (8, '艺术楼', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (9, '演播厅', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (10, '足球场', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (11, '篮球场', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (12, '艺苑', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (13, '学生公寓1幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (14, '学生公寓2幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (15, '学生公寓3幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (16, '学生公寓4幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (17, '学生公寓5幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (18, '学生公寓6幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (19, '学生公寓7幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (20, '学生公寓8幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (21, '学生公寓9幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (22, '学生公寓10幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (23, '学生公寓11幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (24, '学生公寓12幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (25, '学生公寓13幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (26, '学生公寓14幢', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (27, '教师公寓A', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (28, '教师公寓B', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (29, '教师公寓C', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (30, '教师公寓D', 1);
INSERT INTO LAF.SCOPE (SCOPE_ID, LOC_NAME, DISPLAY) VALUES (31, '教师公寓E', 1);

CREATE TABLE LAF.LAFADMIN
(
    ADMIN_ID NUMBER(*) PRIMARY KEY NOT NULL,
    USER_NAME VARCHAR2(20) NOT NULL,
    PASSWORD VARCHAR2(15) NOT NULL
);

INSERT INTO LAF.LAFADMIN (ADMIN_ID, USER_NAME, PASSWORD) VALUES (1, 'admin', 'scgs123456');

CREATE TABLE LAF.USERINFO
(
    USER_ID NUMBER(*) DEFAULT NULL PRIMARY KEY NOT NULL,
    USER_NAME VARCHAR2(15) NOT NULL,
    PASSWORD VARCHAR2(15) NOT NULL,
    EMAIL VARCHAR2(50) DEFAULT NULL NOT NULL,
    PHONE VARCHAR2(11) NOT NULL,
    QUESTION NUMBER(*) NOT NULL,
    ANSWER VARCHAR2(20) NOT NULL,
    REG_TIME DATE DEFAULT sysdate NOT NULL,
    LOG_TIME DATE DEFAULT null,
    DISPLAY NUMBER(*) DEFAULT 1 NOT NULL,
    CONSTRAINT USERINFO_QUESTION_QUE_ID_FK FOREIGN KEY (QUESTION) REFERENCES LAF.QUESTION (QUE_ID)
);
CREATE UNIQUE INDEX USERINFO_USER_NAME_UINDEX ON LAF.USERINFO (USER_NAME);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (3, 'zhangsan', '123', '1256488214@qq.com', '12547893587', 2, '张启蒙', TO_DATE('2018-09-27 20:04:39', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-08-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (31, '1234', '123', '126@qq.com', '12345678911', 16, '123', TO_DATE('2018-10-08 12:12:56', 'YYYY-MM-DD HH24:MI:SS'), null, 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (5, 'lisi', 'lisi', '45723488214@qq.com', '12547893587', 2, '李琴', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-07-20 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (6, 'tom', 'tom', '4536488214@qq.com', '12547893587', 2, '谭杰希', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-06-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (7, 'harris', 'harris', '456488214@qq.com', '12547893587', 2, '航瑞', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-05-10 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (8, 'andy', 'andy', '12555485@qq.com', '12547893587', 2, '安娜', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-07-11 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (9, 'jack', 'jack', '1336484537@qq.com', '12547893587', 2, '杰瑞', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-06-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (10, 'pangpang', 'pangpang', '18415882@qq.com', '12547893587', 2, '胖迪', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-05-13 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (11, 'wangda', 'wangda', '148673783@qq.com', '12547893587', 2, '王洋', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-07-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);
INSERT INTO LAF.USERINFO (USER_ID, USER_NAME, PASSWORD, EMAIL, PHONE, QUESTION, ANSWER, REG_TIME, LOG_TIME, DISPLAY) VALUES (12, 'panda', 'panda', '1423876@qq.com', '12547893587', 2, '潘孔', TO_DATE('2018-09-27 20:08:02', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-09-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1);

CREATE TABLE LAF.NOTICE
(
    NOTICE_ID NUMBER(*) PRIMARY KEY NOT NULL,
    TITLE VARCHAR2(100),
    CATE_ID NUMBER(*) NOT NULL,
    NOTICE_TIME DATE DEFAULT sysdate NOT NULL,
    SCOPE_ID NUMBER(*) NOT NULL,
    LOCATION VARCHAR2(50),
    DESCRIBE VARCHAR2(100),
    IMAGE1 VARCHAR2(30),
    IMAGE2 VARCHAR2(30),
    IMAGE3 VARCHAR2(30),
    LINKMAN VARCHAR2(20) NOT NULL,
    PHONE VARCHAR2(11) NOT NULL,
    QQ VARCHAR2(12),
    EMAIL VARCHAR2(20),
    TYPE NUMBER(*) NOT NULL,
    STATUS NUMBER(*) DEFAULT 1 NOT NULL,
    DISPLAY NUMBER(*) DEFAULT 1 NOT NULL,
    CONSTRAINT NOTICE_CATEGORY_CATE_ID_FK FOREIGN KEY (CATE_ID) REFERENCES LAF.CATEGORY (CATE_ID),
    CONSTRAINT NOTICE_SCOPE_SCOPE_ID_FK FOREIGN KEY (SCOPE_ID) REFERENCES LAF.SCOPE (SCOPE_ID)
);

INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (1, '小组佩奇的钥匙一串', 2, TO_DATE('2018-10-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3306教室', '第二排捡到的', '小猪佩奇钥匙.jpg', null, null, '青山', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (2, '带有QQ图案的钥匙一串', 2, TO_DATE('2018-09-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3212教室', '第一排桌子里面捡到的', 'QQ钥匙.jpg', null, null, '张强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (3, '带有海豚的钥匙一串', 2, TO_DATE('2018-09-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3312教室', '第一排桌子里面捡到的', '海豚钥匙.jpg', null, null, '张勇', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (4, '钥匙一串，共有三把钥匙', 2, TO_DATE('2018-08-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C302教室', '最后一排桌子里面捡到的', '三把钥匙.jpg', null, null, '李散', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (5, '捡到1把钥匙', 2, TO_DATE('2018-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C509教室', '最后一排桌子里面捡到的', '一把钥匙.png', null, null, '王凯', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (6, '捡到1把钥匙带有U盘一个', 2, TO_DATE('2018-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C306教室', '教室里的桌子里面捡到的', '钥匙1.jpg', null, null, '鞥从', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (7, '捡到钥匙5把，还要一个指甲剪', 2, TO_DATE('2018-02-05 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C406教室', '教室里的桌子里面捡到的', '钥匙2.jpg', null, null, '邪王', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (8, '捡到钥匙一串，还要一个指甲剪', 2, TO_DATE('2018-06-23 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '1212教室', '教室第三排捡到的', '钥匙3.jpg', null, null, '程强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (9, '捡到钥匙一把', 2, TO_DATE('2018-07-20 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '1304教室', '教室门口捡到的', '钥匙4.jpg', null, null, '晴空', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (10, '捡到钥匙两把', 2, TO_DATE('2018-08-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 5, '二楼', '走廊捡到的', '钥匙5.jpg', null, null, '何洋', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (11, '捡到钥匙一串', 2, TO_DATE('2018-08-21 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 6, '图书馆三楼', '阅览室桌子上的', '钥匙6.jpg', null, null, '卢青', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (12, '捡到钥匙三把', 2, TO_DATE('2018-04-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 6, '图书馆二楼', '大厅桌子上的', '钥匙7.jpg', null, null, '卢张', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (13, '捡到钥匙三把', 2, TO_DATE('2018-04-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, '跑道上捡的', '钥匙三把还有一个U盘', '钥匙8.jpg', null, null, '蝎王', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (14, '捡到钥匙一把', 2, TO_DATE('2018-09-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 11, '篮球场中间', '这个地点不好描述看图片', '钥匙9.jpg', null, null, '瓦卡', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (15, '捡到饭卡一张，没有写名字的', 1, TO_DATE('2018-01-06 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3310', '教室第一排见到的', '饭卡.jpg', null, null, '何洁', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (16, '捡到饭卡一张，背面刻一个y', 1, TO_DATE('2018-01-06 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3511', '教室第三排见到的', '饭卡1.jpg', null, null, '何洁', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (17, '捡到饭卡一张，外面套了狗狗卡套', 1, TO_DATE('2018-02-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C501', '教室第三排见到的', '饭卡2.jpg', null, null, '谢洁', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (18, '捡到饭卡一张，外面套了卡通卡套', 1, TO_DATE('2018-03-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C509', '教室最后一排见到的', '饭卡3.jpg', null, null, '阚人', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (19, '捡到饭卡一张', 1, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1, '2C109', '教室最后一排见到的', '饭卡4.jpg', null, null, '谢红', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (20, '捡到饭卡一张，读卡器写的张红', 1, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 1, '球门附近', '球门边上捡到的', '饭卡5.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (21, '捡到钱包一个，里有银行卡2张，身份证1张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '在食堂打饭偶然看见的', '钱包1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (22, '捡到钱包一个，里有银行卡1张，现金若干', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '哪位少侠的钱包', '钱包2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (23, '捡到钱包一个，里有银行卡2张，身份证1张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '黑色的钱包', '钱包3.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (24, '钱包一个，有何**身份证1张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '卡通的女士钱包', '钱包4.png', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (25, '捡到钱包一个，有银行卡1张，饭卡一张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '一个七匹狼的黑色钱包', '钱包5.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (26, '钱包一个，里有银行卡3张，现金若干', 3, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', '钱包6.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (27, '捡到U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (28, '捡到金士顿U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (29, '捡到aigo U盘一个，链子一条', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘3.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (30, '捡到闪迪U盘一个，还有一把钥匙', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘4.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (31, '闪迪U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘5.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (32, '捡到金士顿U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘6.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (33, '同方U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘7.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (34, '捡到索尼U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘8.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (35, '闪迪U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘9.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (36, '捡到金士顿U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'U盘10.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (37, 'JAVA书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'java1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (38, '捡到C#书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置捡到的', 'c1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (39, '捡到数据库原理书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '2楼走廊', '靠近厕所的位置捡到的', '数据库.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (40, '捡到高等数学-下书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3楼走廊', '靠近楼梯的位置', '高数下1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (41, '捡到高等数学-上书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '1楼走廊', '书桌边上', '高数上1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (42, '捡到朝花夕拾书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '301', '第三排桌子上', '朝花夕拾1.jpeg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (43, '捡到生死疲劳书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '111教室门口捡到的', '生死疲劳1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (44, '捡到外语书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 14, '312', '靠近厕所的位置捡到的', '外语1.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 1, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (45, '小猪佩奇镜子', 6, TO_DATE('2018-10-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3306教室', '哪位丢了了麻烦通知一下', '镜子2.jpg', null, null, '青山', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (46, '桃木梳一把', 6, TO_DATE('2018-09-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3212教室', '第一排桌子', 'QQ钥匙.jpg', null, null, '张强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (47, '带有海豚的钥匙一串', 2, TO_DATE('2018-09-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3312教室', '第一排桌子里面丢了的', '海豚钥匙.jpg', null, null, '张勇', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (48, '钥匙一串，共有三把钥匙', 2, TO_DATE('2018-08-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C302教室', '最后一排桌子里面丢了的', '三把钥匙.jpg', null, null, '李散', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (49, '1把钥匙', 2, TO_DATE('2018-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C509教室', '最后一排桌子里面丢了的', '一把钥匙.png', null, null, '王凯', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (50, '1把钥匙带有U盘一个', 2, TO_DATE('2018-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C306教室', '教室里的桌子里面丢了的', '钥匙1.jpg', null, null, '鞥从', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (51, '钥匙5把，还要一个指甲剪', 2, TO_DATE('2018-02-05 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C406教室', '教室里的桌子里面丢了的', '佩奇钥匙.jpg', null, null, '邪王', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (52, '钥匙一串，还要一个指甲剪', 2, TO_DATE('2018-06-23 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '1212教室', '教室第三排丢了的', '钥匙3.jpg', null, null, '程强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (53, '钥匙一把', 2, TO_DATE('2018-07-20 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '1304教室', '教室门口丢了的', '钥匙10.jpg', null, null, '晴空', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (54, '钥匙两把', 2, TO_DATE('2018-08-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 5, '二楼', '走廊丢了的', '钥匙9.jpg', null, null, '何洋', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (55, '钥匙一串', 2, TO_DATE('2018-08-21 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 6, '图书馆三楼', '阅览室桌子上的', '钥匙6.jpg', null, null, '卢青', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (56, '丢了钥匙三把', 2, TO_DATE('2018-04-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 6, '图书馆二楼', '大厅桌子上的', '钥匙8.jpg', null, null, '卢张', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (57, '丢了钥匙三把', 2, TO_DATE('2018-04-22 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, '跑道上捡的', '钥匙三把还有一个U盘', '钥匙8.jpg', null, null, '蝎王', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (58, '丢了钥匙一把', 2, TO_DATE('2018-09-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 11, '篮球场中间', '这个地点不好描述看图片', '钱包13.jpg', null, null, '瓦卡', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (59, '丢了饭卡一张，没有写名字的', 1, TO_DATE('2018-01-06 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3310', '教室第一排见到的', '饭卡.jpg', null, null, '何洁', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (60, '丢了饭卡一张，背面刻一个y', 1, TO_DATE('2018-01-06 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3511', '教室第三排见到的', '饭卡10.JPG', null, null, '何洁', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (61, '饭卡一张，外面套了狗狗卡套', 1, TO_DATE('2018-02-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C501', '教室第三排见到的', '饭卡9.JPG', null, null, '谢洁', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (62, '丢了饭卡一张，外面套了卡通卡套', 1, TO_DATE('2018-03-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C509', '教室最后一排见到的', '饭卡8.JPG', null, null, '阚人', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (63, '丢了饭卡一张', 1, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '2C109', '教室最后一排见到的', '饭卡7.JPG', null, null, '谢红', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (64, '丢了饭卡一张，读卡器写的张红', 1, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, '球门附近', '磨损严重的饭卡', '饭卡6.JPG', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (65, '丢了钱包一个，里有银行卡2张，身份证1张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '上面雕刻了一个字母J', '钱包2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (66, '钱包一个，里有银行卡1张，现金若干', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '红色钱包，对我十分重要', '钱包11.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (67, '丢了钱包一个，里有银行卡2张，身份证1张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '钱包里面有我重要的卡片', '钱包10.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (68, '钱包一个，有何**身份证1张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 12, '食堂里面', '哪位好心人麻烦捡到联系我', '钱包9.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (69, '丢了钱包一个，有银行卡1张，饭卡一张', 3, TO_DATE('2018-09-18 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '食堂里面', '这个钱包对我十分重要，捡到请联系我，谢谢', '钱包8.jpg', '钱包8.jpg', '钱包8.jpg', '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (70, '钱包一个，里有银行卡3张，现金若干', 3, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', '钱包7.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (71, '丢了U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘11.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (72, '丢了金士顿U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘12.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (73, '丢了aigo U盘一个，链子一条', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘13.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (74, '丢了闪迪U盘一个，还有一把钥匙', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘14.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (75, '闪迪U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘15.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (76, '丢了金士顿U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘16.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (77, '同方U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘17.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (78, '丢了索尼U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘18.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (79, '闪迪U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘19.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (80, '丢了金士顿U盘一个', 4, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'U盘.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (81, 'JAVA书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'java2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (82, '丢了C#书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '靠近厕所的位置丢了的', 'c2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (83, '丢了数据库原理书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '2楼走廊', '靠近厕所的位置丢了的', '数据库2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (84, '丢了高等数学-下书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '3楼走廊', '靠近楼梯的位置', '高数下2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (85, '高等数学-上书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2, '1楼走廊', '书桌边上', '高数上2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (86, '丢了朝花夕拾书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 3, '301', '第三排桌子上', '朝花夕拾2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (87, '生死疲劳书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 4, '3楼走廊', '111教室门口丢了的', '生死疲劳2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (88, '丢了外语书籍一本', 5, TO_DATE('2018-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 14, '312', '靠近厕所的位置丢了的', '外语2.jpg', null, null, '成强', '12548751269', '1365478', '135431553@qq.com', 0, 1, 1);
INSERT INTO LAF.NOTICE (NOTICE_ID, TITLE, CATE_ID, NOTICE_TIME, SCOPE_ID, LOCATION, DESCRIBE, IMAGE1, IMAGE2, IMAGE3, LINKMAN, PHONE, QQ, EMAIL, TYPE, STATUS, DISPLAY) VALUES (89, '捡到一个书包，里面有钱包若干', 3, TO_DATE('2018-10-08 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 11, '篮球架附件', '水池边上的那个篮球场最靠近足球场的位置捡到的', '1538979921076.jpeg', null, null, '王琦', '13658745965', '123165482', '123165482@qq.com', 0, 1, 1);


CREATE TABLE LAF.LEAVE
(
    LEAVE_ID NUMBER(*) PRIMARY KEY NOT NULL,
    USER_ID NUMBER(*) NOT NULL,
    NOTICE_ID NUMBER(*) NOT NULL,
    CONTENT VARCHAR2(100) NOT NULL,
    LEAVE_TIME DATE DEFAULT sysdate NOT NULL,
    CONSTRAINT LEAVE_USERINFO_USER_ID_FK FOREIGN KEY (USER_ID) REFERENCES LAF.USERINFO (USER_ID),
    CONSTRAINT LEAVE_NOTICE_NOTICE_ID_FK FOREIGN KEY (NOTICE_ID) REFERENCES LAF.NOTICE (NOTICE_ID)
);

INSERT INTO LAF.LEAVE (LEAVE_ID, USER_ID, NOTICE_ID, CONTENT, LEAVE_TIME) VALUES (1, 3, 3, '我才掉过这个！', TO_DATE('2018-10-01 17:56:04', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO LAF.LEAVE (LEAVE_ID, USER_ID, NOTICE_ID, CONTENT, LEAVE_TIME) VALUES (2, 5, 3, '我也是，尴尬！', TO_DATE('2018-10-01 17:57:01', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO LAF.LEAVE (LEAVE_ID, USER_ID, NOTICE_ID, CONTENT, LEAVE_TIME) VALUES (3, 6, 3, '我好像见到', TO_DATE('2018-10-01 17:57:19', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO LAF.LEAVE (LEAVE_ID, USER_ID, NOTICE_ID, CONTENT, LEAVE_TIME) VALUES (4, 5, 1, '心疼你！', TO_DATE('2018-10-08 14:12:48', 'YYYY-MM-DD HH24:MI:SS'));

CREATE TABLE LAF.APPLY
(
    APPLY_ID NUMBER(*) PRIMARY KEY NOT NULL,
    PROPOSER NUMBER(*) NOT NULL,
    NOTICE_ID NUMBER(*) NOT NULL,
    APPLY_TIME TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
    STATUS NUMBER(*) DEFAULT 1 NOT NULL,
    DISPLAY NUMBER(*) DEFAULT 1 NOT NULL,
    CONSTRAINT APPLY_USERINFO_USER_ID_FK2 FOREIGN KEY (PROPOSER) REFERENCES LAF.USERINFO (USER_ID),
    CONSTRAINT APPLY_NOTICE_NOTICE_ID_FK FOREIGN KEY (NOTICE_ID) REFERENCES LAF.NOTICE (NOTICE_ID)
);

INSERT INTO LAF.APPLY (APPLY_ID, PROPOSER, NOTICE_ID, APPLY_TIME, STATUS, DISPLAY) VALUES (1, 3, 78, TO_TIMESTAMP('2018-10-02 11:51:28.407000', 'YYYY-MM-DD HH24:MI:SS.FF6'), 1, 1);
INSERT INTO LAF.APPLY (APPLY_ID, PROPOSER, NOTICE_ID, APPLY_TIME, STATUS, DISPLAY) VALUES (2, 5, 78, TO_TIMESTAMP('2018-10-02 11:51:51.566000', 'YYYY-MM-DD HH24:MI:SS.FF6'), 1, 1);
INSERT INTO LAF.APPLY (APPLY_ID, PROPOSER, NOTICE_ID, APPLY_TIME, STATUS, DISPLAY) VALUES (3, 5, 21, TO_TIMESTAMP('2018-10-02 12:28:35.339000', 'YYYY-MM-DD HH24:MI:SS.FF6'), 1, 1);